Eecient Incremental Evaluation of Queries with Aggregation
نویسندگان
چکیده
We present a technique for eeciently evaluating queries on programs with mono-tonic aggregation, a class of programs deened by Ross and Sagiv. Our technique consists of the following components: incremental computation of aggregate functions , incremental xpoint evaluation of monotonic programs and Magic Sets transformation of monotonic programs. We also present a formalization of the notion of incremental computation of aggregate functions on a multiset, and upper and lower bounds for incremental computation of a variety of aggregate functions. We describe a proof-theoretic reformulation of the monotonic semantics in terms of computations , following the approach of Beeri et al.; this reformulation greatly simpliies the task of proving the correctness of our optimizations.
منابع مشابه
Pcube: Update-eecient Online Aggregation with Progressive Feedback and Error Bounds
Data Cubes are used in large data warehouses as a tool for online aggregation of information. Typically , online aggregation is supported by specifying a range query over a multidimensional data cube. As the number of dimensions increases, supporting eecient range queries as well as updates to the data cube becomes diicult. Another problem that arises with increased dimensionality is the sparse...
متن کاملEfficient Incremental Evaluation of Queries with Aggregation
We present a technique for eeciently evaluating queries on programs with mono-tonic aggregation, a class of programs deened by Ross and Sagiv. Our technique consists of the following components: incremental computation of aggregate functions , incremental xpoint evaluation of monotonic programs and Magic Sets transformation of monotonic programs. We also present a formalization of the notion of...
متن کاملIncremental Aggregation on Multiple Continuous Queries
Continuously monitoring large-scale aggregates over data streams is important for many stream processing applications, e.g. collaborative intelligence analysis, and presents new challenges to data management systems. The first challenge is to efficiently generate the updated aggregate values and provide the new results to users after new tuples arrive. We implemented an incremental aggregation ...
متن کاملOptimizing Multiple Continuous Queries
Emerging data stream processing applications present new challenges that are not addressed by traditional DBMS technologies. To provide practical solutions for matching highly dynamic data streams with multiple long-lived and dynamically-updated continuous queries, a stream processing system should support incremental evaluation over new data, query optimization for continuous queries including...
متن کاملEfficient Top-Down Computation of Queries under the Well-Founded Semantics
The well-founded model provides a natural and robust semantics for logic programs with negative literals in the bodies of rules. Although various procedural semantics have been proposed for query evaluation under the well-founded semantics, the practical issues of implementation for eeective and eecient computation of queries have been rarely discussed. This paper investigates two major impleme...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 1994